|
Courses >
Computer Applications > Introduction to Microsoft Excel 2003
 Work with numbers? Then you need to learn Excel 2003. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons.
This course includes a knowledgeable and caring instructor who will guide you through your lessons, facilitate discussions, and answer your questions. The instructor for this course will be Craig Power.
 Craig Power has worked in adult continuing education for more than 18 years. A UCLA graduate, he created custom accounting software for state and local governments; developed an online course delivery and marketing platform currently used by more than 1,500 colleges and universities in the US, Canada, and Australia; developed an interactive cellular biology video for the Los Angeles Unified School District; taught college-level information technology courses; started and grew a thriving small business; and served as an executive with a large academic publishing corporation.
To purchase this course, click the Enroll Now button below:
Requirements:
Microsoft Windows XP or 2000, Microsoft Excel 2003 or Microsoft Office 2003 (Student and Teacher Edition, Standard Edition, Small Business Edition, or Professional Edition are all acceptable - please be sure to install the software on your computer before the course begins), Internet access, e-mail, and the Microsoft Internet Explorer or Mozilla Firefox Web browser.
This course is not suitable for Macintosh users, nor for users of any of the 2007 versions of Microsoft Excel.
Syllabus:
All courses run for six weeks, with a two-week grace period at the end. Two lessons are released each week for the six-week duration of the course. You do not have to be present when the lesson is released, but you must complete each lesson within two weeks of its release.
A new section of each course starts on the second or third Wednesday of each month. If enrolling in a series of two or more courses, please be sure to space the start date for each course at least two months apart.
| Week One |
| Wednesday - Lesson 01 |
Excel Terminology; Navigation and Editing; Constant Values vs. Formulas
|
| Friday - Lesson 02 |
Creating a Worksheet: Labels, Values, Formulas, and Formatting
|
| Week Two |
| Wednesday - Lesson 03 |
Time-Savers
|
| Friday - Lesson 04 |
Relative, Absolute, and Circular References
|
| Week Three |
| Wednesday - Lesson 05 |
Sheet References; Creating 3-Dimensional Workbooks; Linking Files
|
| Friday - Lesson 06 |
Sorting and Subtotaling
|
| Week Four |
| Wednesday - Lesson 07 |
Creating Graphs: The Chart Wizard
|
| Friday - Lesson 08 |
Advanced Graphing Techniques
|
| Week Five |
| Wednesday - Lesson 09 |
Statistics Made Easy: The Function Wizard
|
| Friday - Lesson 10 |
Financial Functions; Amortization
|
| Week Six |
| Wednesday - Lesson 11 |
Worksheet Automation: Creating Macros and Customizing Toolbars
|
| Friday - Lesson 12 |
Creating Worksheets with Decision-Making Capabilities
|
To purchase this course, click the Enroll Now button below:
Student Reviews:
"I enjoyed the practical, real world tie in that the instructor used. I think this gave me a more of an advantage since I don't work on Excel as much."
"I found this course to be an excellent way to learn Excel 2003, and would recommend it to others. The curriculum had a good organization and sequencing, was well written and easy to follow."
"I learned many new features of Excel which I had not stumbled upon in my many years of using it. THANKS very much for a very effective course."
"I really liked the course. After being out school for better than 13 years, I was afraid I would have trouble. It went very well. I actually had fun. Thank You and I look forward to the next course."
"Loved this course. I knew a little bit of Excel when I started, but even from the first lesson I learned things that I didn't know. I have taught my boyfriend how to link worksheets and this has helped him with his job. I have now signed up for the intermediate course."
"The instructor had an excellent approach to teaching this class. The material flowed nicely, keeping my interest. In short, the instructor helped you to understand the how's and why's of a sometimes complex subject."
"This course has helped me tremendously both at work and at home."
"This was a great course. I will recommend to my manager that others in our department need to take this course. I was impressed by what I learned that Excel can do for me. Thanks for the great work!"
"Working full time and keeping a household going, I didn't think I would be able to complete this course. I have already started using this program to help me at work and it has made a great difference in getting work done faster. I can't wait to apply it at home."
To purchase this course, click the Enroll Now button below:
Recommended Courses:
Students who enrolled in Introduction to Microsoft Excel 2003 were also interested in the following courses:
Advanced Microsoft Excel 2003
Accounting Fundamentals
Introduction to Microsoft Excel 2007
Intermediate Microsoft Excel 2003
Introduction to QuickBooks 2007
|
